---
title: Resolve code-table lookups
summary: Populate dropdown/code-table lookup lists (attorney types, case status, hearing locations, and related joined reference data) consumed across most domains in this library.
status: draft
owner: SAIF Case Management team
last_reviewed: 2026-08-21
library: SAIF.Business.Claim.Legal
reference_type: embedded
operation_id: OP-CLL-020
trigger: Any screen or business object requests dropdown/code-table data
---

# Resolve code-table lookups

Populate dropdown/code-table lookup lists (attorney types, case status, hearing locations, and related joined reference data) consumed across most domains in this library.

| Field | Value |
|---|---|
| **Operation ID** | OP-CLL-020 |
| **Trigger** | Any screen or business object requests dropdown/code-table data |
| **Inputs** | Business-object criteria properties set by the caller (see linked SQL parameter tables) |
| **Outputs** | Persisted/retrieved `mdlCodeTables` state |
| **Primary components** | `mdlCodeTables` |
| **Entry point** | `SAIF.Business.Claim.Legal\mdlCodeTables.vb` |

## Steps

1. Execute the underlying data access for `mdlCodeTables` against: [DB-CLL-CT-001](../sql/SQL-CT001-mdlcodetables.md)
   - Tables affected: [ADP_EMPLOYEE](../database-tables.md#adp_employee), [ATTORNEY_PROFILE](../database-tables.md#code-table-lookup-pattern), [LEGAL_PERSON](../database-tables.md#legal_person), [LEGAL_PERSON_TYPE](../database-tables.md#legal_person_type), [OTHER_FIRM](../database-tables.md#other_firm), [HEARING_LOCATION](../database-tables.md#hearing_location)
2. Return the resulting object graph (or success/failure status) to the caller.

## Process flow

```mermaid
flowchart TD
	Start([Any screen or business object requests dropdown/code-table data]) --> Validate[Validate business rules]
	Validate --> Decision{Valid?}
	Decision -->|No| EndErr([Return validation errors])
	Decision -->|Yes| Exec[Execute data access for mdlCodeTables]
	Exec --> EndOk([Return result])
```

## Failure and edge-case behavior

- Validation failure: the operation returns collected errors without persisting any change.

## Related documentation
- [Operations and processes](../operations-processes.md)
- [Business rules](../business-rules.md)
- [SQL catalog](../sql/index.md)
- [Database tables](../database-tables.md)

## Sources
- `SAIF.Business.Claim.Legal\` (mdlCodeTables)